<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `fanwe_purpose_cate_type_city_link`;");
E_C("CREATE TABLE `fanwe_purpose_cate_type_city_link` (
  `cate_type_id` int(11) NOT NULL,
  `city_id` int(11) NOT NULL,
  `recommend` tinyint(4) NOT NULL DEFAULT '0',
  `rec_sort` int(11) NOT NULL DEFAULT '0',
  KEY `cate_id` (`cate_type_id`),
  KEY `city_id` (`city_id`),
  KEY `index_001` (`cate_type_id`,`city_id`),
  KEY `index_002` (`cate_type_id`,`city_id`,`recommend`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8");
E_D("replace into `fanwe_purpose_cate_type_city_link` values('5','15','0','0');");
E_D("replace into `fanwe_purpose_cate_type_city_link` values('3','15','1','0');");
E_D("replace into `fanwe_purpose_cate_type_city_link` values('2','15','0','0');");
E_D("replace into `fanwe_purpose_cate_type_city_link` values('1','15','1','0');");
E_D("replace into `fanwe_purpose_cate_type_city_link` values('6','15','0','0');");
E_D("replace into `fanwe_purpose_cate_type_city_link` values('7','15','0','0');");
E_D("replace into `fanwe_purpose_cate_type_city_link` values('8','15','0','0');");
E_D("replace into `fanwe_purpose_cate_type_city_link` values('9','15','1','0');");
E_D("replace into `fanwe_purpose_cate_type_city_link` values('10','15','0','0');");
E_D("replace into `fanwe_purpose_cate_type_city_link` values('11','15','1','0');");
E_D("replace into `fanwe_purpose_cate_type_city_link` values('12','15','1','0');");
E_D("replace into `fanwe_purpose_cate_type_city_link` values('13','15','1','100');");
E_D("replace into `fanwe_purpose_cate_type_city_link` values('14','15','1','0');");
E_D("replace into `fanwe_purpose_cate_type_city_link` values('15','15','1','0');");
E_D("replace into `fanwe_purpose_cate_type_city_link` values('16','15','1','0');");
E_D("replace into `fanwe_purpose_cate_type_city_link` values('17','15','1','0');");
E_D("replace into `fanwe_purpose_cate_type_city_link` values('18','15','1','0');");
E_D("replace into `fanwe_purpose_cate_type_city_link` values('20','15','1','0');");
E_D("replace into `fanwe_purpose_cate_type_city_link` values('19','15','1','0');");

require("../../inc/footer.php");
?>